package com.citcc4.traffic.data.domain.user;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BankCardEntityExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer pageNo = 1;

    protected Integer startRow;

    protected Integer pageSize = 10;

    protected String fields;

    public BankCardEntityExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setPageNo(Integer pageNo) {
        this.pageNo=pageNo;
        this.startRow = (pageNo-1)*this.pageSize;
    }

    public Integer getPageNo() {
        return pageNo;
    }

    public void setStartRow(Integer startRow) {
        this.startRow=startRow;
    }

    public Integer getStartRow() {
        return startRow;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize=pageSize;
        this.startRow = (pageNo-1)*this.pageSize;
    }

    public Integer getPageSize() {
        return pageSize;
    }

    public void setFields(String fields) {
        this.fields=fields;
    }

    public String getFields() {
        return fields;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andCardIdIsNull() {
            addCriterion("CARD_ID is null");
            return (Criteria) this;
        }

        public Criteria andCardIdIsNotNull() {
            addCriterion("CARD_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCardIdEqualTo(String value) {
            addCriterion("CARD_ID =", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotEqualTo(String value) {
            addCriterion("CARD_ID <>", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThan(String value) {
            addCriterion("CARD_ID >", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_ID >=", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdLessThan(String value) {
            addCriterion("CARD_ID <", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdLessThanOrEqualTo(String value) {
            addCriterion("CARD_ID <=", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdLike(String value) {
            addCriterion("CARD_ID like", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotLike(String value) {
            addCriterion("CARD_ID not like", value, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdIn(List<String> values) {
            addCriterion("CARD_ID in", values, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotIn(List<String> values) {
            addCriterion("CARD_ID not in", values, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdBetween(String value1, String value2) {
            addCriterion("CARD_ID between", value1, value2, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardIdNotBetween(String value1, String value2) {
            addCriterion("CARD_ID not between", value1, value2, "cardId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdIsNull() {
            addCriterion("CARD_USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andCardUserIdIsNotNull() {
            addCriterion("CARD_USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCardUserIdEqualTo(String value) {
            addCriterion("CARD_USER_ID =", value, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdNotEqualTo(String value) {
            addCriterion("CARD_USER_ID <>", value, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdGreaterThan(String value) {
            addCriterion("CARD_USER_ID >", value, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_USER_ID >=", value, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdLessThan(String value) {
            addCriterion("CARD_USER_ID <", value, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdLessThanOrEqualTo(String value) {
            addCriterion("CARD_USER_ID <=", value, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdLike(String value) {
            addCriterion("CARD_USER_ID like", value, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdNotLike(String value) {
            addCriterion("CARD_USER_ID not like", value, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdIn(List<String> values) {
            addCriterion("CARD_USER_ID in", values, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdNotIn(List<String> values) {
            addCriterion("CARD_USER_ID not in", values, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdBetween(String value1, String value2) {
            addCriterion("CARD_USER_ID between", value1, value2, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardUserIdNotBetween(String value1, String value2) {
            addCriterion("CARD_USER_ID not between", value1, value2, "cardUserId");
            return (Criteria) this;
        }

        public Criteria andCardBankIsNull() {
            addCriterion("CARD_BANK is null");
            return (Criteria) this;
        }

        public Criteria andCardBankIsNotNull() {
            addCriterion("CARD_BANK is not null");
            return (Criteria) this;
        }

        public Criteria andCardBankEqualTo(String value) {
            addCriterion("CARD_BANK =", value, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankNotEqualTo(String value) {
            addCriterion("CARD_BANK <>", value, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankGreaterThan(String value) {
            addCriterion("CARD_BANK >", value, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_BANK >=", value, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankLessThan(String value) {
            addCriterion("CARD_BANK <", value, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankLessThanOrEqualTo(String value) {
            addCriterion("CARD_BANK <=", value, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankLike(String value) {
            addCriterion("CARD_BANK like", value, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankNotLike(String value) {
            addCriterion("CARD_BANK not like", value, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankIn(List<String> values) {
            addCriterion("CARD_BANK in", values, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankNotIn(List<String> values) {
            addCriterion("CARD_BANK not in", values, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankBetween(String value1, String value2) {
            addCriterion("CARD_BANK between", value1, value2, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankNotBetween(String value1, String value2) {
            addCriterion("CARD_BANK not between", value1, value2, "cardBank");
            return (Criteria) this;
        }

        public Criteria andCardBankNumIsNull() {
            addCriterion("CARD_BANK_NUM is null");
            return (Criteria) this;
        }

        public Criteria andCardBankNumIsNotNull() {
            addCriterion("CARD_BANK_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andCardBankNumEqualTo(String value) {
            addCriterion("CARD_BANK_NUM =", value, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumNotEqualTo(String value) {
            addCriterion("CARD_BANK_NUM <>", value, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumGreaterThan(String value) {
            addCriterion("CARD_BANK_NUM >", value, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_BANK_NUM >=", value, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumLessThan(String value) {
            addCriterion("CARD_BANK_NUM <", value, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumLessThanOrEqualTo(String value) {
            addCriterion("CARD_BANK_NUM <=", value, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumLike(String value) {
            addCriterion("CARD_BANK_NUM like", value, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumNotLike(String value) {
            addCriterion("CARD_BANK_NUM not like", value, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumIn(List<String> values) {
            addCriterion("CARD_BANK_NUM in", values, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumNotIn(List<String> values) {
            addCriterion("CARD_BANK_NUM not in", values, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumBetween(String value1, String value2) {
            addCriterion("CARD_BANK_NUM between", value1, value2, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCardBankNumNotBetween(String value1, String value2) {
            addCriterion("CARD_BANK_NUM not between", value1, value2, "cardBankNum");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeIsNull() {
            addCriterion("CAERTE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeIsNotNull() {
            addCriterion("CAERTE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeEqualTo(Date value) {
            addCriterion("CAERTE_TIME =", value, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeNotEqualTo(Date value) {
            addCriterion("CAERTE_TIME <>", value, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeGreaterThan(Date value) {
            addCriterion("CAERTE_TIME >", value, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CAERTE_TIME >=", value, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeLessThan(Date value) {
            addCriterion("CAERTE_TIME <", value, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeLessThanOrEqualTo(Date value) {
            addCriterion("CAERTE_TIME <=", value, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeIn(List<Date> values) {
            addCriterion("CAERTE_TIME in", values, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeNotIn(List<Date> values) {
            addCriterion("CAERTE_TIME not in", values, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeBetween(Date value1, Date value2) {
            addCriterion("CAERTE_TIME between", value1, value2, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andCaerteTimeNotBetween(Date value1, Date value2) {
            addCriterion("CAERTE_TIME not between", value1, value2, "caerteTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andDeleteStateIsNull() {
            addCriterion("DELETE_STATE is null");
            return (Criteria) this;
        }

        public Criteria andDeleteStateIsNotNull() {
            addCriterion("DELETE_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteStateEqualTo(String value) {
            addCriterion("DELETE_STATE =", value, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateNotEqualTo(String value) {
            addCriterion("DELETE_STATE <>", value, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateGreaterThan(String value) {
            addCriterion("DELETE_STATE >", value, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateGreaterThanOrEqualTo(String value) {
            addCriterion("DELETE_STATE >=", value, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateLessThan(String value) {
            addCriterion("DELETE_STATE <", value, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateLessThanOrEqualTo(String value) {
            addCriterion("DELETE_STATE <=", value, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateLike(String value) {
            addCriterion("DELETE_STATE like", value, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateNotLike(String value) {
            addCriterion("DELETE_STATE not like", value, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateIn(List<String> values) {
            addCriterion("DELETE_STATE in", values, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateNotIn(List<String> values) {
            addCriterion("DELETE_STATE not in", values, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateBetween(String value1, String value2) {
            addCriterion("DELETE_STATE between", value1, value2, "deleteState");
            return (Criteria) this;
        }

        public Criteria andDeleteStateNotBetween(String value1, String value2) {
            addCriterion("DELETE_STATE not between", value1, value2, "deleteState");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlIsNull() {
            addCriterion("CARD_IMG_URL is null");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlIsNotNull() {
            addCriterion("CARD_IMG_URL is not null");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlEqualTo(String value) {
            addCriterion("CARD_IMG_URL =", value, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlNotEqualTo(String value) {
            addCriterion("CARD_IMG_URL <>", value, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlGreaterThan(String value) {
            addCriterion("CARD_IMG_URL >", value, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_IMG_URL >=", value, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlLessThan(String value) {
            addCriterion("CARD_IMG_URL <", value, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlLessThanOrEqualTo(String value) {
            addCriterion("CARD_IMG_URL <=", value, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlLike(String value) {
            addCriterion("CARD_IMG_URL like", value, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlNotLike(String value) {
            addCriterion("CARD_IMG_URL not like", value, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlIn(List<String> values) {
            addCriterion("CARD_IMG_URL in", values, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlNotIn(List<String> values) {
            addCriterion("CARD_IMG_URL not in", values, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlBetween(String value1, String value2) {
            addCriterion("CARD_IMG_URL between", value1, value2, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardImgUrlNotBetween(String value1, String value2) {
            addCriterion("CARD_IMG_URL not between", value1, value2, "cardImgUrl");
            return (Criteria) this;
        }

        public Criteria andCardTypeIsNull() {
            addCriterion("CARD_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCardTypeIsNotNull() {
            addCriterion("CARD_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCardTypeEqualTo(String value) {
            addCriterion("CARD_TYPE =", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotEqualTo(String value) {
            addCriterion("CARD_TYPE <>", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeGreaterThan(String value) {
            addCriterion("CARD_TYPE >", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_TYPE >=", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeLessThan(String value) {
            addCriterion("CARD_TYPE <", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeLessThanOrEqualTo(String value) {
            addCriterion("CARD_TYPE <=", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeLike(String value) {
            addCriterion("CARD_TYPE like", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotLike(String value) {
            addCriterion("CARD_TYPE not like", value, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeIn(List<String> values) {
            addCriterion("CARD_TYPE in", values, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotIn(List<String> values) {
            addCriterion("CARD_TYPE not in", values, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeBetween(String value1, String value2) {
            addCriterion("CARD_TYPE between", value1, value2, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardTypeNotBetween(String value1, String value2) {
            addCriterion("CARD_TYPE not between", value1, value2, "cardType");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeIsNull() {
            addCriterion("CARD_BANK_CODE is null");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeIsNotNull() {
            addCriterion("CARD_BANK_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeEqualTo(String value) {
            addCriterion("CARD_BANK_CODE =", value, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeNotEqualTo(String value) {
            addCriterion("CARD_BANK_CODE <>", value, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeGreaterThan(String value) {
            addCriterion("CARD_BANK_CODE >", value, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_BANK_CODE >=", value, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeLessThan(String value) {
            addCriterion("CARD_BANK_CODE <", value, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeLessThanOrEqualTo(String value) {
            addCriterion("CARD_BANK_CODE <=", value, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeLike(String value) {
            addCriterion("CARD_BANK_CODE like", value, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeNotLike(String value) {
            addCriterion("CARD_BANK_CODE not like", value, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeIn(List<String> values) {
            addCriterion("CARD_BANK_CODE in", values, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeNotIn(List<String> values) {
            addCriterion("CARD_BANK_CODE not in", values, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeBetween(String value1, String value2) {
            addCriterion("CARD_BANK_CODE between", value1, value2, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andCardBankCodeNotBetween(String value1, String value2) {
            addCriterion("CARD_BANK_CODE not between", value1, value2, "cardBankCode");
            return (Criteria) this;
        }

        public Criteria andVailDateIsNull() {
            addCriterion("VAIL_DATE is null");
            return (Criteria) this;
        }

        public Criteria andVailDateIsNotNull() {
            addCriterion("VAIL_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andVailDateEqualTo(String value) {
            addCriterion("VAIL_DATE =", value, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateNotEqualTo(String value) {
            addCriterion("VAIL_DATE <>", value, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateGreaterThan(String value) {
            addCriterion("VAIL_DATE >", value, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateGreaterThanOrEqualTo(String value) {
            addCriterion("VAIL_DATE >=", value, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateLessThan(String value) {
            addCriterion("VAIL_DATE <", value, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateLessThanOrEqualTo(String value) {
            addCriterion("VAIL_DATE <=", value, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateLike(String value) {
            addCriterion("VAIL_DATE like", value, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateNotLike(String value) {
            addCriterion("VAIL_DATE not like", value, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateIn(List<String> values) {
            addCriterion("VAIL_DATE in", values, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateNotIn(List<String> values) {
            addCriterion("VAIL_DATE not in", values, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateBetween(String value1, String value2) {
            addCriterion("VAIL_DATE between", value1, value2, "vailDate");
            return (Criteria) this;
        }

        public Criteria andVailDateNotBetween(String value1, String value2) {
            addCriterion("VAIL_DATE not between", value1, value2, "vailDate");
            return (Criteria) this;
        }

        public Criteria andCardNameIsNull() {
            addCriterion("CARD_NAME is null");
            return (Criteria) this;
        }

        public Criteria andCardNameIsNotNull() {
            addCriterion("CARD_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andCardNameEqualTo(String value) {
            addCriterion("CARD_NAME =", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameNotEqualTo(String value) {
            addCriterion("CARD_NAME <>", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameGreaterThan(String value) {
            addCriterion("CARD_NAME >", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_NAME >=", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameLessThan(String value) {
            addCriterion("CARD_NAME <", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameLessThanOrEqualTo(String value) {
            addCriterion("CARD_NAME <=", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameLike(String value) {
            addCriterion("CARD_NAME like", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameNotLike(String value) {
            addCriterion("CARD_NAME not like", value, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameIn(List<String> values) {
            addCriterion("CARD_NAME in", values, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameNotIn(List<String> values) {
            addCriterion("CARD_NAME not in", values, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameBetween(String value1, String value2) {
            addCriterion("CARD_NAME between", value1, value2, "cardName");
            return (Criteria) this;
        }

        public Criteria andCardNameNotBetween(String value1, String value2) {
            addCriterion("CARD_NAME not between", value1, value2, "cardName");
            return (Criteria) this;
        }

        public Criteria andCeratorIsNull() {
            addCriterion("CERATOR is null");
            return (Criteria) this;
        }

        public Criteria andCeratorIsNotNull() {
            addCriterion("CERATOR is not null");
            return (Criteria) this;
        }

        public Criteria andCeratorEqualTo(String value) {
            addCriterion("CERATOR =", value, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorNotEqualTo(String value) {
            addCriterion("CERATOR <>", value, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorGreaterThan(String value) {
            addCriterion("CERATOR >", value, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorGreaterThanOrEqualTo(String value) {
            addCriterion("CERATOR >=", value, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorLessThan(String value) {
            addCriterion("CERATOR <", value, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorLessThanOrEqualTo(String value) {
            addCriterion("CERATOR <=", value, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorLike(String value) {
            addCriterion("CERATOR like", value, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorNotLike(String value) {
            addCriterion("CERATOR not like", value, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorIn(List<String> values) {
            addCriterion("CERATOR in", values, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorNotIn(List<String> values) {
            addCriterion("CERATOR not in", values, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorBetween(String value1, String value2) {
            addCriterion("CERATOR between", value1, value2, "cerator");
            return (Criteria) this;
        }

        public Criteria andCeratorNotBetween(String value1, String value2) {
            addCriterion("CERATOR not between", value1, value2, "cerator");
            return (Criteria) this;
        }

        public Criteria andModifierIsNull() {
            addCriterion("MODIFIER is null");
            return (Criteria) this;
        }

        public Criteria andModifierIsNotNull() {
            addCriterion("MODIFIER is not null");
            return (Criteria) this;
        }

        public Criteria andModifierEqualTo(String value) {
            addCriterion("MODIFIER =", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotEqualTo(String value) {
            addCriterion("MODIFIER <>", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierGreaterThan(String value) {
            addCriterion("MODIFIER >", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierGreaterThanOrEqualTo(String value) {
            addCriterion("MODIFIER >=", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierLessThan(String value) {
            addCriterion("MODIFIER <", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierLessThanOrEqualTo(String value) {
            addCriterion("MODIFIER <=", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierLike(String value) {
            addCriterion("MODIFIER like", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotLike(String value) {
            addCriterion("MODIFIER not like", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierIn(List<String> values) {
            addCriterion("MODIFIER in", values, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotIn(List<String> values) {
            addCriterion("MODIFIER not in", values, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierBetween(String value1, String value2) {
            addCriterion("MODIFIER between", value1, value2, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotBetween(String value1, String value2) {
            addCriterion("MODIFIER not between", value1, value2, "modifier");
            return (Criteria) this;
        }

        public Criteria andCardBindStateIsNull() {
            addCriterion("CARD_BIND_STATE is null");
            return (Criteria) this;
        }

        public Criteria andCardBindStateIsNotNull() {
            addCriterion("CARD_BIND_STATE is not null");
            return (Criteria) this;
        }

        public Criteria andCardBindStateEqualTo(String value) {
            addCriterion("CARD_BIND_STATE =", value, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateNotEqualTo(String value) {
            addCriterion("CARD_BIND_STATE <>", value, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateGreaterThan(String value) {
            addCriterion("CARD_BIND_STATE >", value, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateGreaterThanOrEqualTo(String value) {
            addCriterion("CARD_BIND_STATE >=", value, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateLessThan(String value) {
            addCriterion("CARD_BIND_STATE <", value, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateLessThanOrEqualTo(String value) {
            addCriterion("CARD_BIND_STATE <=", value, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateLike(String value) {
            addCriterion("CARD_BIND_STATE like", value, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateNotLike(String value) {
            addCriterion("CARD_BIND_STATE not like", value, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateIn(List<String> values) {
            addCriterion("CARD_BIND_STATE in", values, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateNotIn(List<String> values) {
            addCriterion("CARD_BIND_STATE not in", values, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateBetween(String value1, String value2) {
            addCriterion("CARD_BIND_STATE between", value1, value2, "cardBindState");
            return (Criteria) this;
        }

        public Criteria andCardBindStateNotBetween(String value1, String value2) {
            addCriterion("CARD_BIND_STATE not between", value1, value2, "cardBindState");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}